<table width="100%" border="1">
  <tr><th>Page</th><th>Author</th><th>Time</th></tr>
<?php
// pagination?
$revisions = sqlite_fetch_all(sqlite_query($db,"SELECT * FROM revisions ORDER BY time DESC"));
foreach($revisions as $revision) {
  $title = sqlite_fetch_single(sqlite_query($db,"SELECT title FROM pages WHERE id=".$revision['pageid']));
  echo "<tr>";
  echo "<td><a href='?show=$title'>$title</td>";
  echo "<td>".$revision['author']."</td>";
  echo "<td>".date("g:ia - l, n/j/Y",$revision['time'])."</td>";
  echo "</tr>";
}
?>
</table>